2013-10-18 - 9591.100 - Rel Notes - Rewrite BI FI Reports to use New Query - Release 001 #BIReleases2013
Release Notes
9591.100 - Rewrite BI FI Reports to use New Query
Admin Info
Purpose
|
Need to Rewrite BI FI Reports to use New Query
|
Release No
|
001
|
Submitted
|
10/18/2013
|
Submitted by
|
Praveen Guntuka
|
Source/Destination Systems
|
IT > BMS > Production in Development Server to Reports > Financial Statements folder in Production Server
|
Release Sent To
|
Lori Miterko
|
Object(s) Created By
|
Praveen Guntuka
|
Object(s) Tested By
|
Joan Profetta
|
Report Name
FI100 - Consolidated Income Statement
BEx Query
Main Report: ZMP_GLPC_Q004
Sub Report : ZMP_GLPC_Q004
NEC Crystal Reports Standards Check
1. FI100 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. FI100 NEC CR checklist has been sent to NEC and also attached here for reference:
FI100 NEC CR Standard Check List.xlsx
Summary Level Check
Test Conducted
NEC Corporate > THIS YEAR VS BUDGET > Sales Net
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
76,603,344
|
76,603,344
|
Pass
|
2
|
Budget
|
63,824,695
|
63,824,695
|
Pass
|
3
|
Variance
|
12,778,649
|
12,778,649
|
Pass
|
4
|
Var%
|
20
|
20
|
Pass
|
5
|
Actual
|
523,949,762
|
523,949,762
|
Pass
|
6
|
Budget
|
550,112,527
|
550,112,527
|
Pass
|
7
|
Variance
|
-26,162,765
|
-26,162,765
|
Pass
|
8
|
Var%
|
-5
|
-5
|
Pass
|
NEC Corporate > THIS YEAR VS BUDGET > Selling and Distribution expenses
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
30,263,193
|
30,263,193
|
Pass
|
2
|
Budget
|
25,930,103
|
25,930,103
|
Pass
|
3
|
Variance
|
4,333,090
|
4,333,090
|
Pass
|
4
|
Var%
|
17
|
17
|
Pass
|
5
|
Actual
|
213,614,416
|
213,614,416
|
Pass
|
6
|
Budget
|
226,235,047
|
226,235,047
|
Pass
|
7
|
Variance
|
-12,620,631
|
-12,620,631
|
Pass
|
8
|
Var%
|
-6
|
-6
|
Pass
|
NEC Corporate> THIS YEAR VS LAST YEAR > Other Income(expenses )
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
30,263,193
|
30,263,193
|
Pass
|
2
|
Budget
|
25,930,103
|
25,930,103
|
Pass
|
3
|
Variance
|
4,333,090
|
4,333,090
|
Pass
|
4
|
Var%
|
17
|
17
|
Pass
|
5
|
Actual
|
213,614,416
|
213,614,416
|
Pass
|
6
|
Budget
|
226,235,047
|
226,235,047
|
Pass
|
7
|
Variance
|
-12,620,631
|
-12,620,631
|
Pass
|
8
|
Var%
|
-6
|
-6
|
Pass
|
Detail Level Check
Test Conducted
NEC Corporate> THIS YEAR VS BUDGET > Cost of goods sold > Purchases
SNo
|
Test Case
|
Value in DEV report
|
Value in Production Report
|
Pass/Fail
|
1
|
Actual
|
24,578,084
|
24,578,084
|
Pass
|
2
|
Budget
|
20,502,035
|
20,502,035
|
Pass
|
3
|
Variance
|
4,076,049
|
4,076,049
|
Pass
|
4
|
Var%
|
16
|
16
|
Pass
|
5
|
Actual
|
180,270,272
|
180,270,272
|
Pass
|
6
|
Budget
|
195,941,523
|
180,270,272
|
Pass
|
7
|
Variance
|
-15,671,251
|
-15,671,251
|
Pass
|
8
|
Var%
|
-8
|
-8
|
Pass
|
Reference Document (Specification)
2013-10-18 - 9591.100 - Spec - Rewrite BI FI Reports to use New Query